select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Green and Black Ruffled Organza Ruched Quinceanera Dresses
Black and Blue Organza Quinceanera Dresses with Ruffles
Two Toned Ruffled Organza Beaded Sweet Sixteen Dresses
Two Toned Ball Gown Organza Beaded Dress for Quinceaneras
Two Toned Sweetheart Tulle Quinceanera Dresses with Beading
Two Toned Layered Organza Appliques Sweet Sixteen Dresses
Multi Color One Shoulder Dress for Quinceaneras with Ruffles Beyonce dress
Multi Color Organza Sweet Sixteen Dresses with Ruffles
Multi Color Sweetheart Tulle Beaded Sweet Sixteen Dresses
Fuchsia Ball Gown Embroidery Sweet Sixteen Dresses Floor-length
Lace Hem Decorated Strapless Quinceanera Dresses Custom Made
Strapless Beaded Bodice Fuchsia Quinceanera Dress with Pick-ups
Two-toned Sweetheart Ruffles Dresses Quinceanera with Appliques
Ball Gown Beaded and Ruched Dresses for a Quinceanera in Style
Multi-colored Sweetheart Dresses for a Quince with Ruffled Layers
American Music Awards Recommended Ball Gown Beading Sweet 15 Dresses with Pick-ups
Paris Fashion Week Ruched and Beaded Sweetheart Dress for a Quinceanera with Ruffles
Hot Pink Pick-ups Sweet Sixteen Dresses with Beading and Ruches
Multi-colored Pick-ups and Ruffles Dresses for a Quince Hot Sale
Beading Sweetheart Apple Green Dresses for Sweet 16 with Ruffles
berlin film festival 2014 Two-toned Strapless Beading Quinceanera Dresses in Organza
Yellow One Shoulder Applique Quince Dresses with Ruffled Layers
Colorful Off the Shoulder Appliques Quinceanera Gown in Organza
Leopard Printed Beading Sweetheart Quinceanera Dress with Ruffle
Lovely Strapless Ruffles Dress for Quince with Floral Embellishment
Luxurious Strapless Two-toned Sweet Fifteen Dresses with Ruffles
Two-toned Ruffles Sweetheart Quinceanera Party Dress in Organza
Yellow Green Organza Ruffles Dresses Quinceanera with Appliques
Colorful Ruffles Vestidos De Quinceanera with Ruches and Beading
Purple and White Embroidery Dress for Quince in Taffeta and Tulle